CREATE VIEW [dbo].[vWorkflowQueueWithStatus]
AS
SELECT WorkFlowQueueKey, WorkItems, Description, TaskItemKey, SelectionKey, Stage, DateExecuted, CreatedOn, CreatedByUserKey, UpdatedOn,
               UpdatedByUserKey, MarkedForDeleteOn, TaskItemAccessKey,
               CASE WorkFlowQueueItemStatusCode WHEN 0 THEN 'Not Started' WHEN 1 THEN 'In Progress' WHEN 2 THEN 'Completed' WHEN 4 THEN 'Aborted' WHEN
                8 THEN 'Validation Failed' WHEN 16 THEN 'Cancelled' WHEN 1028 THEN 'Unknown' ELSE CAST(WorkFlowQueueItemStatusCode AS nvarchar(100))
               END AS Status
FROM  dbo.WorkflowQueue


GO